{ "statement" :"SELECT /*+ set_var(new_planner_optimize_timeout = 10000) */ mocktable.business_line_name, mocktable.closetime, mocktable.complain_id, mocktable.complaintsource, mocktable.cpr_area_name, mocktable.dep_city, mocktable.dep_prov, mocktable.departure_date, mocktable.dest_province_name, mocktable.destination_city, mocktable.destination_country, mocktable.detail, mocktable.distribution_channel_id, mocktable.domain_name, mocktable.fault_category_name, mocktable.first_exam_target, mocktable.first_reason, mocktable.is_business_reason, mocktable.is_cpr_order, mocktable.is_examine, mocktable.issuetime, mocktable.local_tag, mocktable.order_date, mocktable.orderid, mocktable.pkg_region, mocktable.plc_prd_name, mocktable.pm_eid, mocktable.prd_line_name, mocktable.product_category_name, mocktable.product_id, mocktable.product_level_name, mocktable.product_pattern_name, mocktable.provider_id, mocktable.qa_pkgregion, mocktable.qa_region_name, mocktable.quality_id, mocktable.returndate, mocktable.sale_model_name, mocktable.second_exam_target, mocktable.second_reason, mocktable.source_from_name, mocktable.status, mocktable.themetagname, mocktable.tour_region_type, mocktable.vendor_name, mocktable.weekinput, SUM(mocktable.b_quality_cost) AS m_a0, SUM(mocktable.communication_cost) AS m_b1, SUM(CAST(mocktable.customerprice as DOUBLE)) AS m_c2, SUM(mocktable.paymentmoney) AS m_d3, SUM(mocktable.quality_cost) AS m_e4, SUM(mocktable.servicelabor_cost) AS m_f5\nFROM (SELECT DISTINCT o.*, r.userno\nFROM (SELECT a.*, b.sale_mode, b.dest_domain, b.dest_first_region, b.dest_second_region, b.bu_type, b.prd_pat_name, b.distr_channel, c.issuetime, c.closetime, c.complaintsource, d.detail, d.status, d.datachange_createtime, SUBSTR(d.datachange_createtime, 1, 10) AS datachange_createdate, b.dep_city, b.dep_prov, b.plc_prd_name, b.vendor_name, b.return_date AS returndate, b.cpr_area_name, b.plc_prd_tags, p.is_gold_guider_prd\nFROM dw_diydb.adm_sev_qa_quality_dmt_t AS a\nLEFT JOIN dw_diydb.edw_ord_tor_order_ext_d AS b ON (a.orderid = b.order_id)\nLEFT JOIN (SELECT DISTINCT complaintsid, issuetime, closetime, complaintsource\nFROM dw_diydb.vacationcomplaint_widetable\nWHERE (d = '2023-07-26')) AS c ON (a.complain_id = c.complaintsid)\nLEFT JOIN ods_vacdb.m_tourqualitycenterdb_qa_quality AS d ON (a.quality_id = d.quality_id)\nLEFT JOIN (SELECT productid, is_gold_guider_prd\nFROM dw_diydb.dim_prd_tor_pkg_ext\nWHERE (d = '2023-07-26')) AS p ON (CAST(a.product_id as DOUBLE) = CAST(p.productid as DOUBLE))\nWHERE ((b.d = '2023-07-26') AND (d.d = '2023-07-26'))) AS o\nINNER JOIN (SELECT r1.*\nFROM dw_diydb.vacation_permission AS r1\nWHERE (LOWER(r1.userno) = LOWER('TR008959'))) AS r ON ((((((((COALESCE(o.sale_mode, '')) = (COALESCE(r.salemode, o.sale_mode, ''))) AND ((COALESCE(o.dest_domain, '')) = (COALESCE(r.domain, o.dest_domain, '')))) AND ((COALESCE(o.dest_first_region, '')) = (COALESCE(r.destfirstregion, o.dest_first_region, '')))) AND ((COALESCE(o.dest_second_region, '')) = (COALESCE(r.destsecregion, o.dest_second_region, '')))) AND ((COALESCE(o.bu_type, '')) = (COALESCE(r.butype, o.bu_type, '')))) AND ((COALESCE(o.prd_pat_name, '')) = (COALESCE(r.productpatternname, o.prd_pat_name, '')))) AND ((COALESCE(CAST(LOWER(o.distr_channel) as VARCHAR), '')) = (COALESCE(CAST(LOWER(r.distributionchannel) as VARCHAR), CAST(LOWER(o.distr_channel) as VARCHAR), ''))))) AS mocktable\nWHERE (((((mocktable.qa_pkgregion = '广东代理组') AND ((mocktable.departure_date >= '2023-05-25') AND (mocktable.departure_date <= '2023-08-23'))) AND (mocktable.domain_name IN ('海外'))) AND ((mocktable.departure_date >= '2023-07-19') AND (mocktable.departure_date < '2023-07-26'))) AND (mocktable.is_examine = '是'))\nGROUP BY mocktable.business_line_name, mocktable.closetime, mocktable.complain_id, mocktable.complaintsource, mocktable.cpr_area_name, mocktable.dep_city, mocktable.dep_prov, mocktable.departure_date, mocktable.dest_province_name, mocktable.destination_city, mocktable.destination_country, mocktable.detail, mocktable.distribution_channel_id, mocktable.domain_name, mocktable.fault_category_name, mocktable.first_exam_target, mocktable.first_reason, mocktable.is_business_reason, mocktable.is_cpr_order, mocktable.is_examine, mocktable.issuetime, mocktable.local_tag, mocktable.order_date, mocktable.orderid, mocktable.pkg_region, mocktable.plc_prd_name, mocktable.pm_eid, mocktable.prd_line_name, mocktable.product_category_name, mocktable.product_id, mocktable.product_level_name, mocktable.product_pattern_name, mocktable.provider_id, mocktable.qa_pkgregion, mocktable.qa_region_name, mocktable.quality_id, mocktable.returndate, mocktable.sale_model_name, mocktable.second_exam_target, mocktable.second_reason, mocktable.source_from_name, mocktable.status, mocktable.themetagname, mocktable.tour_region_type, mocktable.vendor_name, mocktable.weekinput\nLIMIT 2000\n",
  "table_meta": { "dw_diydb.adm_sev_qa_quality_dmt_t" :"CREATE TABLE `adm_sev_qa_quality_dmt_t` (\n  `quality_id` bigint(20) NOT NULL COMMENT \"\",\n  `orderid` bigint(20) NULL COMMENT \"\",\n  `order_date` varchar(1048576) NULL COMMENT \"\",\n  `departure_date` varchar(1048576) NULL COMMENT \"\",\n  `weekinput` varchar(1048576) NULL COMMENT \"\",\n  `business_line` varchar(1048576) NULL COMMENT \"\",\n  `business_line_name` varchar(1048576) NULL COMMENT \"\",\n  `qa_region_name` varchar(1048576) NULL COMMENT \"\",\n  `product_pattern_id` varchar(1048576) NULL COMMENT \"\",\n  `product_pattern_name` varchar(1048576) NULL COMMENT \"\",\n  `product_category_id` varchar(1048576) NULL COMMENT \"\",\n  `product_category_name` varchar(1048576) NULL COMMENT \"\",\n  `domain_id` varchar(1048576) NULL COMMENT \"\",\n  `domain_name` varchar(1048576) NULL COMMENT \"\",\n  `qa_pkgregion` varchar(1048576) NULL COMMENT \"\",\n  `pkg_region` varchar(1048576) NULL COMMENT \"\",\n  `sale_model_id` varchar(1048576) NULL COMMENT \"\",\n  `sale_model_name` varchar(1048576) NULL COMMENT \"\",\n  `distribution_channel_id` varchar(1048576) NULL COMMENT \"\",\n  `product_level_id` varchar(1048576) NULL COMMENT \"\",\n  `product_level_name` varchar(1048576) NULL COMMENT \"\",\n  `dest_province_name` varchar(1048576) NULL COMMENT \"\",\n  `provider_id` varchar(1048576) NULL COMMENT \"\",\n  `pm_eid` varchar(1048576) NULL COMMENT \"\",\n  `product_id` varchar(1048576) NULL COMMENT \"\",\n  `first_exam_target` varchar(1048576) NULL COMMENT \"\",\n  `second_exam_target` varchar(1048576) NULL COMMENT \"\",\n  `third_exam_target` varchar(1048576) NULL COMMENT \"\",\n  `source_from_id` varchar(1048576) NULL COMMENT \"\",\n  `source_from_name` varchar(1048576) NULL COMMENT \"\",\n  `complain_id` bigint(20) NULL COMMENT \"\",\n  `origin_first_reason` varchar(1048576) NULL COMMENT \"\",\n  `origin_second_reason` varchar(1048576) NULL COMMENT \"\",\n  `origin_fault_category_id` varchar(1048576) NULL COMMENT \"\",\n  `origin_fault_category_name` varchar(1048576) NULL COMMENT \"\",\n  `first_reason` varchar(1048576) NULL COMMENT \"\",\n  `second_reason` varchar(1048576) NULL COMMENT \"\",\n  `fault_category_id` varchar(1048576) NULL COMMENT \"\",\n  `fault_category_name` varchar(1048576) NULL COMMENT \"\",\n  `customer_value` decimal64(10, 2) NULL COMMENT \"\",\n  `customer_feel` int(11) NULL COMMENT \"\",\n  `complain_up_factor` decimal64(10, 2) NULL COMMENT \"\",\n  `is_business_reason` varchar(1048576) NULL COMMENT \"\",\n  `paymentmoney` decimal128(29, 2) NULL COMMENT \"\",\n  `customerprice` double NULL COMMENT \"\",\n  `servicelabor_cost` double NULL COMMENT \"\",\n  `communication_cost` double NULL COMMENT \"\",\n  `timeanswer` double NULL COMMENT \"\",\n  `a_quality_cost` decimal128(29, 2) NULL COMMENT \"\",\n  `unit_quality_cost` double NULL COMMENT \"\",\n  `b_quality_cost` double NULL COMMENT \"\",\n  `quality_cost` decimal128(29, 2) NULL COMMENT \"\",\n  `complain_orderid` bigint(20) NULL COMMENT \"\",\n  `business_reason_orderid` bigint(20) NULL COMMENT \"\",\n  `qa_index` varchar(1048576) NULL COMMENT \"\",\n  `is_examine` varchar(1048576) NULL COMMENT \"\",\n  `destination_country` varchar(1048576) NULL COMMENT \"\",\n  `destination_city` varchar(1048576) NULL COMMENT \"\",\n  `themetagname` varchar(1048576) NULL COMMENT \"\",\n  `distribution_channel_name` varchar(1048576) NULL COMMENT \"\",\n  `return_date` varchar(1048576) NULL COMMENT \"\",\n  `provider_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_line_name` varchar(1048576) NULL COMMENT \"\",\n  `tour_region_type` varchar(1048576) NULL COMMENT \"\",\n  `local_tag` varchar(1048576) NULL COMMENT \"\",\n  `third_reason` varchar(1048576) NULL COMMENT \"\",\n  `is_cpr_order` varchar(1048576) NULL COMMENT \"\",\n  `alloc_coefficient` double NULL COMMENT \"\",\n  `qa_problem_segment` varchar(1048576) NULL COMMENT \"\",\n  `is_core_problem` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`quality_id`, `orderid`)\n DISTRIBUTED BY HASH(`quality_id`, `orderid`) BUCKETS 64 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "dw_diydb.dim_prd_tor_pkg_ext" :"CREATE TABLE `dim_prd_tor_pkg_ext` (\n  `productid` bigint(20) NULL COMMENT \"\",\n  `prd_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_category_id` int(11) NULL COMMENT \"\",\n  `prd_category_name` varchar(1048576) NULL COMMENT \"\",\n  `bu_type` varchar(1048576) NULL COMMENT \"\",\n  `prd_bu_type_id` int(11) NULL COMMENT \"\",\n  `prd_bu_type_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_pattern_id` int(11) NULL COMMENT \"\",\n  `prd_pattern_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_line_id` int(11) NULL COMMENT \"\",\n  `prd_line_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_level_id` int(11) NULL COMMENT \"\",\n  `prd_level_name` varchar(1048576) NULL COMMENT \"\",\n  `dest_first_region` varchar(1048576) NULL COMMENT \"\",\n  `dest_sec_region` varchar(1048576) NULL COMMENT \"\",\n  `prd_region_id` int(11) NULL COMMENT \"\",\n  `prd_region_name` varchar(1048576) NULL COMMENT \"\",\n  `active_status_code` varchar(1048576) NULL COMMENT \"\",\n  `active_status_name` varchar(1048576) NULL COMMENT \"\",\n  `online_status` varchar(1048576) NULL COMMENT \"\",\n  `isonline` int(11) NULL COMMENT \"\",\n  `dest_city_id` int(11) NULL COMMENT \"\",\n  `dest_city_name` varchar(1048576) NULL COMMENT \"\",\n  `dest_province_id` int(11) NULL COMMENT \"\",\n  `dest_province_name` varchar(1048576) NULL COMMENT \"\",\n  `dest_country_id` int(11) NULL COMMENT \"\",\n  `dest_country_name` varchar(1048576) NULL COMMENT \"\",\n  `dest_continent_id` bigint(20) NULL COMMENT \"\",\n  `dest_continent_name` varchar(1048576) NULL COMMENT \"\",\n  `sale_mode_code` varchar(1048576) NULL COMMENT \"\",\n  `sale_mode_name` varchar(1048576) NULL COMMENT \"\",\n  `vendor_id` int(11) NULL COMMENT \"\",\n  `vendor_name` varchar(1048576) NULL COMMENT \"\",\n  `logic_vendor_id` int(11) NULL COMMENT \"\",\n  `logic_vendor_name` varchar(1048576) NULL COMMENT \"\",\n  `tour_vendor_id` int(11) NULL COMMENT \"\",\n  `tour_vendor_name` varchar(1048576) NULL COMMENT \"\",\n  `pm_eid_email` varchar(1048576) NULL COMMENT \"\",\n  `pbm_eid` varchar(1048576) NULL COMMENT \"\",\n  `pm_eid` varchar(1048576) NULL COMMENT \"\",\n  `depa_city_id` int(11) NULL COMMENT \"\",\n  `depa_city_name` varchar(1048576) NULL COMMENT \"\",\n  `depa_province_id` int(11) NULL COMMENT \"\",\n  `depa_province_name` varchar(1048576) NULL COMMENT \"\",\n  `depa_country_id` int(11) NULL COMMENT \"\",\n  `depa_country_name` varchar(1048576) NULL COMMENT \"\",\n  `sale_city_ids` varchar(1048576) NULL COMMENT \"\",\n  `sale_city_names` varchar(1048576) NULL COMMENT \"\",\n  `apro_city_ids` varchar(1048576) NULL COMMENT \"\",\n  `apro_city_names` varchar(1048576) NULL COMMENT \"\",\n  `apro_district_ids` varchar(1048576) NULL COMMENT \"\",\n  `apro_district_names` varchar(1048576) NULL COMMENT \"\",\n  `is_startcities` varchar(1048576) NULL COMMENT \"\",\n  `depa_city_ids` varchar(1048576) NULL COMMENT \"\",\n  `depa_city_names` varchar(1048576) NULL COMMENT \"\",\n  `pa_eid` varchar(1048576) NULL COMMENT \"\",\n  `pay_mode_code` varchar(1048576) NULL COMMENT \"\",\n  `pay_mode_name` varchar(1048576) NULL COMMENT \"\",\n  `payment_type_code` int(11) NULL COMMENT \"\",\n  `payment_type_name` varchar(1048576) NULL COMMENT \"\",\n  `price_hand` int(11) NULL COMMENT \"\",\n  `prd_effect_date` varchar(1048576) NULL COMMENT \"\",\n  `prd_expire_date` varchar(1048576) NULL COMMENT \"\",\n  `advance_booking_days` int(11) NULL COMMENT \"\",\n  `advance_booking_time` varchar(1048576) NULL COMMENT \"\",\n  `is_weekend_work` int(11) NULL COMMENT \"\",\n  `is_holiday_work` int(11) NULL COMMENT \"\",\n  `min_travel_days` int(11) NULL COMMENT \"\",\n  `max_travel_days` int(11) NULL COMMENT \"\",\n  `business_owner` varchar(1048576) NULL COMMENT \"\",\n  `business_owner_flag` varchar(1048576) NULL COMMENT \"\",\n  `datachange_lasttime` varchar(1048576) NULL COMMENT \"\",\n  `is_can_offline_booking` int(11) NULL COMMENT \"\",\n  `is_sku_distribution` int(11) NULL COMMENT \"\",\n  `frt_channel_code` int(11) NULL COMMENT \"\",\n  `frt_channel_name` varchar(1048576) NULL COMMENT \"\",\n  `distributionchannelids` varchar(1048576) NULL COMMENT \"\",\n  `sale_locale_code` varchar(1048576) NULL COMMENT \"\",\n  `sale_locale_name` varchar(1048576) NULL COMMENT \"\",\n  `service_language` varchar(1048576) NULL COMMENT \"\",\n  `input_locale` varchar(1048576) NULL COMMENT \"\",\n  `adv_booking_timezoneid` int(11) NULL COMMENT \"\",\n  `is_auto_calculate_prd_level` int(11) NULL COMMENT \"\",\n  `countryname_poi` varchar(1048576) NULL COMMENT \"\",\n  `cityname_poi` varchar(1048576) NULL COMMENT \"\",\n  `district_name_poi` varchar(1048576) NULL COMMENT \"\",\n  `thm_tagid` bigint(20) NULL COMMENT \"\",\n  `thm_tagname` varchar(1048576) NULL COMMENT \"\",\n  `early_depa_sche` varchar(1048576) NULL COMMENT \"\",\n  `last_depa_sche` varchar(1048576) NULL COMMENT \"\",\n  `vendor_prd_name` varchar(1048576) NULL COMMENT \"\",\n  `is_auto_process` int(11) NULL COMMENT \"\",\n  `auto_prd_tag_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_tag_name` varchar(1048576) NULL COMMENT \"\",\n  `sale_tag_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_createtime` varchar(1048576) NULL COMMENT \"\",\n  `onlinedate` varchar(1048576) NULL COMMENT \"\",\n  `distributionchannel_prd` varchar(1048576) NULL COMMENT \"\",\n  `ext_number` varchar(1048576) NULL COMMENT \"\",\n  `price_description` varchar(1048576) NULL COMMENT \"\",\n  `is_auto_calculate_price` int(11) NULL COMMENT \"\",\n  `is_startcity_mange` int(11) NULL COMMENT \"\",\n  `is_set_risk` int(11) NULL COMMENT \"\",\n  `is_child_prd` int(11) NULL COMMENT \"\",\n  `is_parent_prd` int(11) NULL COMMENT \"\",\n  `child_product_ids` varchar(1048576) NULL COMMENT \"\",\n  `parent_product_id` int(11) NULL COMMENT \"\",\n  `is_package` int(11) NULL COMMENT \"\",\n  `tour_group_id` int(11) NULL COMMENT \"\",\n  `master_line_prdid` int(11) NULL COMMENT \"\",\n  `pack_sort` int(11) NULL COMMENT \"\",\n  `distrbut_price_way_code` varchar(1048576) NULL COMMENT \"\",\n  `distrbut_price_way_name` varchar(1048576) NULL COMMENT \"\",\n  `commition_rate` double NULL COMMENT \"\",\n  `prdcomt_score` decimal64(12, 2) NULL COMMENT \"\",\n  `aggregate_score` decimal64(12, 2) NULL COMMENT \"\",\n  `min_person_quantity` int(11) NULL COMMENT \"\",\n  `max_person_quantity` int(11) NULL COMMENT \"\",\n  `min_lodging_days` int(11) NULL COMMENT \"\",\n  `commission_mode_code` varchar(1048576) NULL COMMENT \"\",\n  `commission_mode_name` varchar(1048576) NULL COMMENT \"\",\n  `child_min_age` int(11) NULL COMMENT \"\",\n  `child_max_age` int(11) NULL COMMENT \"\",\n  `commission` decimal128(20, 4) NULL COMMENT \"\",\n  `is_foradult` int(11) NULL COMMENT \"\",\n  `is_forchild` int(11) NULL COMMENT \"\",\n  `is_promotions` int(11) NULL COMMENT \"\",\n  `travel_nights` int(11) NULL COMMENT \"\",\n  `is_select_nights` int(11) NULL COMMENT \"\",\n  `is_set_commissionenable` int(11) NULL COMMENT \"\",\n  `prd_introduction` varchar(1048576) NULL COMMENT \"\",\n  `is_distribute` int(11) NULL COMMENT \"\",\n  `domain` varchar(1048576) NULL COMMENT \"\",\n  `distributionchannelnames` varchar(1048576) NULL COMMENT \"\",\n  `depa_prov_ids` varchar(1048576) NULL COMMENT \"\",\n  `depa_prov_names` varchar(1048576) NULL COMMENT \"\",\n  `effect_days` int(11) NULL COMMENT \"\",\n  `productid_main` int(11) NULL COMMENT \"\",\n  `pkg_line_desc` varchar(1048576) NULL COMMENT \"\",\n  `brand_id` int(11) NULL COMMENT \"\",\n  `brand_name` varchar(1048576) NULL COMMENT \"\",\n  `poi_name` varchar(1048576) NULL COMMENT \"\",\n  `tour_region_type` varchar(1048576) NULL COMMENT \"\",\n  `mainname` varchar(1048576) NULL COMMENT \"\",\n  `subname` varchar(1048576) NULL COMMENT \"\",\n  `pm_recom_reason` varchar(1048576) NULL COMMENT \"\",\n  `is_high_vipsale` int(11) NULL COMMENT \"\",\n  `stour_pers` varchar(1048576) NULL COMMENT \"\",\n  `poi_ids` varchar(1048576) NULL COMMENT \"\",\n  `is_prov_tour` int(11) NULL COMMENT \"\",\n  `system_train_segnums` int(11) NULL COMMENT \"\",\n  `system_flt_segnums` int(11) NULL COMMENT \"\",\n  `hotel_segnums` int(11) NULL COMMENT \"\",\n  `province_name_poi` varchar(1048576) NULL COMMENT \"\",\n  `is_city_tour` int(11) NULL COMMENT \"\",\n  `tag_names` varchar(1048576) NULL COMMENT \"\",\n  `contract_id` bigint(20) NULL COMMENT \"\",\n  `is_aboard_whitelist` int(11) NULL COMMENT \"\",\n  `is_deleted` int(11) NULL COMMENT \"\",\n  `is_abandoned` int(11) NULL COMMENT \"\",\n  `poi_cnt` bigint(20) NULL COMMENT \"\",\n  `viewspot_cnt` bigint(20) NULL COMMENT \"\",\n  `local_viewpot_rate` double NULL COMMENT \"\",\n  `is_high_class` int(11) NULL COMMENT \"\",\n  `is_judge_foreigner` int(11) NULL COMMENT \"\",\n  `is_self_funded` int(11) NULL COMMENT \"\",\n  `is_eqzt_grp` int(11) NULL COMMENT \"\",\n  `distr_channel_ids` varchar(1048576) NULL COMMENT \"\",\n  `distr_channel_names` varchar(1048576) NULL COMMENT \"\",\n  `around_tag` varchar(1048576) NULL COMMENT \"\",\n  `c_avg_prd_comt_acore` decimal64(6, 2) NULL COMMENT \"\",\n  `prd_manager_cfg_id` bigint(20) NULL COMMENT \"\",\n  `is_sale_front` int(11) NULL COMMENT \"\",\n  `is_next30d_sale_back` int(11) NULL COMMENT \"\",\n  `is_next90d_sale_back` int(11) NULL COMMENT \"\",\n  `createfrom` int(11) NULL COMMENT \"\",\n  `is_cpr_ved` int(11) NULL COMMENT \"\",\n  `cpr_area_name` varchar(1048576) NULL COMMENT \"\",\n  `city_location` varchar(1048576) NULL COMMENT \"\",\n  `is_many_tours` int(11) NULL COMMENT \"\",\n  `pack_type` varchar(1048576) NULL COMMENT \"\",\n  `next90d_earliest_date` varchar(1048576) NULL COMMENT \"\",\n  `next90d_latest_date` varchar(1048576) NULL COMMENT \"\",\n  `pi_category_id` bigint(20) NULL COMMENT \"\",\n  `is_gold_guider_prd` int(11) NULL COMMENT \"\",\n  `plate_tag_name` varchar(1048576) NULL COMMENT \"\",\n  `pre_sale_status_code` int(11) NULL COMMENT \"\",\n  `pre_sale_status_name` varchar(1048576) NULL COMMENT \"\",\n  `pre_sale_productid` bigint(20) NULL COMMENT \"\",\n  `source_productid` bigint(20) NULL COMMENT \"\",\n  `is_inflat_prd` int(11) NULL COMMENT \"\",\n  `open_dest_tag` varchar(1048576) NULL COMMENT \"\",\n  `open_dest_tag_dtl` varchar(1048576) NULL COMMENT \"\",\n  `d` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`productid`)\n DISTRIBUTED BY HASH(`productid`) BUCKETS 64 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "dw_diydb.edw_ord_tor_order_ext_d" :"CREATE TABLE `edw_ord_tor_order_ext_d` (\n  `order_id` bigint(20) NULL COMMENT \"\",\n  `bu_type` varchar(1048576) NULL COMMENT \"\",\n  `sub_bu_type` varchar(1048576) NULL COMMENT \"\",\n  `dest_domain` varchar(1048576) NULL COMMENT \"\",\n  `sale_mode_code` varchar(1048576) NULL COMMENT \"\",\n  `sale_mode` varchar(1048576) NULL COMMENT \"\",\n  `sale_mode_group` varchar(1048576) NULL COMMENT \"\",\n  `tour_agent_region` varchar(1048576) NULL COMMENT \"\",\n  `tour_self_region` varchar(1048576) NULL COMMENT \"\",\n  `order_time` varchar(1048576) NULL COMMENT \"\",\n  `order_date` varchar(1048576) NULL COMMENT \"\",\n  `order_year` varchar(1048576) NULL COMMENT \"\",\n  `order_month` varchar(1048576) NULL COMMENT \"\",\n  `dep_time` varchar(1048576) NULL COMMENT \"\",\n  `dep_date` varchar(1048576) NULL COMMENT \"\",\n  `dep_year` varchar(1048576) NULL COMMENT \"\",\n  `dep_month` varchar(1048576) NULL COMMENT \"\",\n  `pre_order_days` int(11) NULL COMMENT \"\",\n  `return_time` varchar(1048576) NULL COMMENT \"\",\n  `return_date` varchar(1048576) NULL COMMENT \"\",\n  `return_year` varchar(1048576) NULL COMMENT \"\",\n  `return_month` varchar(1048576) NULL COMMENT \"\",\n  `out_days` int(11) NULL COMMENT \"\",\n  `order_status_code` varchar(1048576) NULL COMMENT \"\",\n  `order_status` varchar(1048576) NULL COMMENT \"\",\n  `proc_status_code` int(11) NULL COMMENT \"\",\n  `proc_status` varchar(1048576) NULL COMMENT \"\",\n  `is_cancelled` int(11) NULL COMMENT \"\",\n  `is_all_rfd` int(11) NULL COMMENT \"\",\n  `all_rfd_time` varchar(1048576) NULL COMMENT \"\",\n  `sales_city_id` int(11) NULL COMMENT \"\",\n  `sales_city` varchar(1048576) NULL COMMENT \"\",\n  `sales_prov_id` int(11) NULL COMMENT \"\",\n  `sales_prov` varchar(1048576) NULL COMMENT \"\",\n  `sales_ctry_id` int(11) NULL COMMENT \"\",\n  `sales_ctry` varchar(1048576) NULL COMMENT \"\",\n  `dep_city_id` int(11) NULL COMMENT \"\",\n  `dep_city` varchar(1048576) NULL COMMENT \"\",\n  `dep_prov_id` int(11) NULL COMMENT \"\",\n  `dep_prov` varchar(1048576) NULL COMMENT \"\",\n  `dep_ctry_id` int(11) NULL COMMENT \"\",\n  `dep_ctry` varchar(1048576) NULL COMMENT \"\",\n  `dep_region` varchar(1048576) NULL COMMENT \"\",\n  `is_host_dep_city` int(11) NULL COMMENT \"\",\n  `dest_city_id` int(11) NULL COMMENT \"\",\n  `dest_city` varchar(1048576) NULL COMMENT \"\",\n  `dest_prov_id` int(11) NULL COMMENT \"\",\n  `dest_prov` varchar(1048576) NULL COMMENT \"\",\n  `dest_ctry_id` int(11) NULL COMMENT \"\",\n  `dest_ctry` varchar(1048576) NULL COMMENT \"\",\n  `dest_cont_id` int(11) NULL COMMENT \"\",\n  `dest_cont` varchar(1048576) NULL COMMENT \"\",\n  `prd_id` int(11) NULL COMMENT \"\",\n  `plc_prd_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_name` varchar(1048576) NULL COMMENT \"\",\n  `dest_first_region` varchar(1048576) NULL COMMENT \"\",\n  `dest_second_region` varchar(1048576) NULL COMMENT \"\",\n  `prd_region_id` int(11) NULL COMMENT \"\",\n  `prd_region_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_catg_id` int(11) NULL COMMENT \"\",\n  `prd_catg_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_pat_id` int(11) NULL COMMENT \"\",\n  `prd_pat_name` varchar(1048576) NULL COMMENT \"\",\n  `prd_lvl_code` int(11) NULL COMMENT \"\",\n  `prd_lvl` varchar(1048576) NULL COMMENT \"\",\n  `prd_line_id` int(11) NULL COMMENT \"\",\n  `prd_line_name` varchar(1048576) NULL COMMENT \"\",\n  `is_extn_stay` int(11) NULL COMMENT \"\",\n  `plc_prd_invtr_lvl` int(11) NULL COMMENT \"\",\n  `refer_prd_id` int(11) NULL COMMENT \"\",\n  `refer_prd_name` varchar(1048576) NULL COMMENT \"\",\n  `dest_first_region_lvl2` varchar(1048576) NULL COMMENT \"\",\n  `dest_second_region_lvl2` varchar(1048576) NULL COMMENT \"\",\n  `sdp_prd_pat` varchar(1048576) NULL COMMENT \"\",\n  `sdp_prd_pat_lvl2` varchar(1048576) NULL COMMENT \"\",\n  `bst_store_id` int(11) NULL COMMENT \"\",\n  `bst_store_name` varchar(1048576) NULL COMMENT \"\",\n  `bst_store_city_id` int(11) NULL COMMENT \"\",\n  `bst_store_city` varchar(1048576) NULL COMMENT \"\",\n  `bst_store_prov_id` int(11) NULL COMMENT \"\",\n  `bst_store_prov` varchar(1048576) NULL COMMENT \"\",\n  `bst_store_ctry_id` int(11) NULL COMMENT \"\",\n  `bst_store_ctry` varchar(1048576) NULL COMMENT \"\",\n  `bst_store_inst` varchar(1048576) NULL COMMENT \"\",\n  `bst_store_addr` varchar(1048576) NULL COMMENT \"\",\n  `is_hold_order` int(11) NULL COMMENT \"\",\n  `bst_cntrct_price` double NULL COMMENT \"\",\n  `bst_blnc_price` double NULL COMMENT \"\",\n  `bst_profit` double NULL COMMENT \"\",\n  `bst_profit_rate` double NULL COMMENT \"\",\n  `uid` varchar(1048576) NULL COMMENT \"\",\n  `ctrip_card_no` varchar(1048576) NULL COMMENT \"\",\n  `plc_ctrip_mbr_lvl_code` int(11) NULL COMMENT \"\",\n  `plc_ctrip_mbr_lvl` varchar(1048576) NULL COMMENT \"\",\n  `super_mbr_status` varchar(1048576) NULL COMMENT \"\",\n  `super_mbr_active_date` varchar(1048576) NULL COMMENT \"\",\n  `user_perm_city_id` int(11) NULL COMMENT \"\",\n  `user_perm_city` varchar(1048576) NULL COMMENT \"\",\n  `user_perm_prov_id` int(11) NULL COMMENT \"\",\n  `user_perm_prov` varchar(1048576) NULL COMMENT \"\",\n  `user_perm_ctry_id` int(11) NULL COMMENT \"\",\n  `user_perm_ctry` varchar(1048576) NULL COMMENT \"\",\n  `ctrip_new_old_tag` varchar(1048576) NULL COMMENT \"\",\n  `vac_new_old_tag` varchar(1048576) NULL COMMENT \"\",\n  `contact_np_name` varchar(1048576) NULL COMMENT \"\",\n  `contact_np_tel` varchar(1048576) NULL COMMENT \"\",\n  `contact_np_fax` varchar(1048576) NULL COMMENT \"\",\n  `contact_np_phone` varchar(1048576) NULL COMMENT \"\",\n  `contact_np_email` varchar(1048576) NULL COMMENT \"\",\n  `contact_np_addr` varchar(1048576) NULL COMMENT \"\",\n  `cnslt_uid` varchar(1048576) NULL COMMENT \"\",\n  `cnslt_id` bigint(20) NULL COMMENT \"\",\n  `cnslt_phone` varchar(1048576) NULL COMMENT \"\",\n  `cnslt_city_id` int(11) NULL COMMENT \"\",\n  `cnslt_city` varchar(1048576) NULL COMMENT \"\",\n  `wld_cnslt_uid` varchar(1048576) NULL COMMENT \"\",\n  `wld_cnslt_id` int(11) NULL COMMENT \"\",\n  `wld_cnslt_channel_id` bigint(20) NULL COMMENT \"\",\n  `pm_id` varchar(1048576) NULL COMMENT \"\",\n  `pm_eid` varchar(1048576) NULL COMMENT \"\",\n  `pbm_eid` varchar(1048576) NULL COMMENT \"\",\n  `plc_pa_eid` varchar(1048576) NULL COMMENT \"\",\n  `pa_eid` varchar(1048576) NULL COMMENT \"\",\n  `vendor_id` int(11) NULL COMMENT \"\",\n  `vendor_name` varchar(1048576) NULL COMMENT \"\",\n  `multi_vendor_ids` varchar(1048576) NULL COMMENT \"\",\n  `multi_vendor_names` varchar(1048576) NULL COMMENT \"\",\n  `prd_catg_ids` varchar(1048576) NULL COMMENT \"\",\n  `prd_catg_names` varchar(1048576) NULL COMMENT \"\",\n  `rsrc_biz_owner` varchar(1048576) NULL COMMENT \"\",\n  `alliance_id` int(11) NULL COMMENT \"\",\n  `sid` int(11) NULL COMMENT \"\",\n  `ouid` varchar(1048576) NULL COMMENT \"\",\n  `sku_id` int(11) NULL COMMENT \"\",\n  `sku_distrbtr_id` int(11) NULL COMMENT \"\",\n  `sku_distrbtr_name` varchar(1048576) NULL COMMENT \"\",\n  `sku_pbm_eid` varchar(1048576) NULL COMMENT \"\",\n  `sku_sale_mode_code` varchar(1048576) NULL COMMENT \"\",\n  `sku_sale_mode` varchar(1048576) NULL COMMENT \"\",\n  `distr_channel` varchar(1048576) NULL COMMENT \"\",\n  `distr_channel_aggr` varchar(1048576) NULL COMMENT \"\",\n  `server_from` varchar(1048576) NULL COMMENT \"\",\n  `channel_lvl3_id` int(11) NULL COMMENT \"\",\n  `channel_lvl3_name` varchar(1048576) NULL COMMENT \"\",\n  `channel_lvl2_id` int(11) NULL COMMENT \"\",\n  `channel_lvl2_name` varchar(1048576) NULL COMMENT \"\",\n  `channel_lvl1_id` int(11) NULL COMMENT \"\",\n  `channel_lvl1_name` varchar(1048576) NULL COMMENT \"\",\n  `is_distr_prd` int(11) NULL COMMENT \"\",\n  `is_distr_comsn` int(11) NULL COMMENT \"\",\n  `is_trd_price_distr` int(11) NULL COMMENT \"\",\n  `crm_uid` varchar(1048576) NULL COMMENT \"\",\n  `app_id` varchar(1048576) NULL COMMENT \"\",\n  `booking_channel` varchar(1048576) NULL COMMENT \"\",\n  `booking_type` varchar(1048576) NULL COMMENT \"\",\n  `plc_adult_np` int(11) NULL COMMENT \"\",\n  `plc_child_np` int(11) NULL COMMENT \"\",\n  `plc_no_bed_child_np` int(11) NULL COMMENT \"\",\n  `plc_baby_np` int(11) NULL COMMENT \"\",\n  `plc_np` int(11) NULL COMMENT \"\",\n  `delta_np` int(11) NULL COMMENT \"\",\n  `delta_adult_np` int(11) NULL COMMENT \"\",\n  `delta_child_np` int(11) NULL COMMENT \"\",\n  `suc_np` int(11) NULL COMMENT \"\",\n  `suc_adult_np` int(11) NULL COMMENT \"\",\n  `suc_child_np` int(11) NULL COMMENT \"\",\n  `suc_baby_np` int(11) NULL COMMENT \"\",\n  `fact_plc_adult_np` int(11) NULL COMMENT \"\",\n  `fact_plc_child_np` int(11) NULL COMMENT \"\",\n  `fact_plc_np` int(11) NULL COMMENT \"\",\n  `fact_rfd_np` int(11) NULL COMMENT \"\",\n  `plc_recv_amt` double NULL COMMENT \"\",\n  `stamp_tax` double NULL COMMENT \"\",\n  `gift_card_pay_amt` double NULL COMMENT \"\",\n  `delta_amt` double NULL COMMENT \"\",\n  `gift_card_rfd_amt` double NULL COMMENT \"\",\n  `order_price` double NULL COMMENT \"\",\n  `rec_price` double NULL COMMENT \"\",\n  `order_inner_fee` double NULL COMMENT \"\",\n  `suc_diliver_ticket_fee` double NULL COMMENT \"\",\n  `suc_income` double NULL COMMENT \"\",\n  `order_rfd_amt` double NULL COMMENT \"\",\n  `fact_rfd_amt` double NULL COMMENT \"\",\n  `risk_fee` double NULL COMMENT \"\",\n  `is_htl_cash_pay` int(11) NULL COMMENT \"\",\n  `purch_cost` double NULL COMMENT \"\",\n  `adjust_cost` double NULL COMMENT \"\",\n  `suc_cost` double NULL COMMENT \"\",\n  `suc_profit` double NULL COMMENT \"\",\n  `suc_profit_rate` double NULL COMMENT \"\",\n  `avg_per_suc_income` double NULL COMMENT \"\",\n  `avg_per_suc_profit` double NULL COMMENT \"\",\n  `is_neg_profit` int(11) NULL COMMENT \"\",\n  `suc_pltf_comsn_amt` double NULL COMMENT \"\",\n  `pltf_comsn_rate` double NULL COMMENT \"\",\n  `promo_id` int(11) NULL COMMENT \"\",\n  `coupon_code` varchar(1048576) NULL COMMENT \"\",\n  `coupon_display_name` varchar(1048576) NULL COMMENT \"\",\n  `coupon_name` varchar(1048576) NULL COMMENT \"\",\n  `coupon_type` varchar(1048576) NULL COMMENT \"\",\n  `is_coupon_used` int(11) NULL COMMENT \"\",\n  `suc_promo_inner_fee` double NULL COMMENT \"\",\n  `suc_promo_outer_fee` double NULL COMMENT \"\",\n  `suc_promo_profit_off` double NULL COMMENT \"\",\n  `suc_promo_amt` double NULL COMMENT \"\",\n  `plc_htl_room_cnt` int(11) NULL COMMENT \"\",\n  `plc_train_seg_cnt` int(11) NULL COMMENT \"\",\n  `plc_x_rsrc_cnt` int(11) NULL COMMENT \"\",\n  `plc_flt_seg_cnt` int(11) NULL COMMENT \"\",\n  `lang` varchar(1048576) NULL COMMENT \"\",\n  `currency` varchar(1048576) NULL COMMENT \"\",\n  `exchg_rate` double NULL COMMENT \"\",\n  `oper_eid` varchar(1048576) NULL COMMENT \"\",\n  `is_bill_order` int(11) NULL COMMENT \"\",\n  `is_spec_sale` int(11) NULL COMMENT \"\",\n  `is_social_serv_order` int(11) NULL COMMENT \"\",\n  `is_click_farming` int(11) NULL COMMENT \"\",\n  `is_ibu` int(11) NULL COMMENT \"\",\n  `is_indpt_order` int(11) NULL COMMENT \"\",\n  `is_spec_prd` int(11) NULL COMMENT \"\",\n  `is_spec_dp` int(11) NULL COMMENT \"\",\n  `is_btdz` int(11) NULL COMMENT \"\",\n  `is_not_spec` int(11) NULL COMMENT \"\",\n  `is_real_loss` int(11) NULL COMMENT \"\",\n  `is_suc_order` int(11) NULL COMMENT \"\",\n  `cancel_reason` varchar(1048576) NULL COMMENT \"\",\n  `cancel_time` varchar(1048576) NULL COMMENT \"\",\n  `cancel_date` varchar(1048576) NULL COMMENT \"\",\n  `pay_time` varchar(1048576) NULL COMMENT \"\",\n  `pay_date` varchar(1048576) NULL COMMENT \"\",\n  `prepay_type` varchar(1048576) NULL COMMENT \"\",\n  `payment_type_code` int(11) NULL COMMENT \"\",\n  `payment_type` varchar(1048576) NULL COMMENT \"\",\n  `tour_id` bigint(20) NULL COMMENT \"\",\n  `tour_status` varchar(1048576) NULL COMMENT \"\",\n  `tour_no` varchar(1048576) NULL COMMENT \"\",\n  `tour_name` varchar(1048576) NULL COMMENT \"\",\n  `tour_type` varchar(1048576) NULL COMMENT \"\",\n  `tour_effect_date` varchar(1048576) NULL COMMENT \"\",\n  `tour_expire_date` varchar(1048576) NULL COMMENT \"\",\n  `tour_days` int(11) NULL COMMENT \"\",\n  `tour_create_time` varchar(1048576) NULL COMMENT \"\",\n  `tour_create_date` varchar(1048576) NULL COMMENT \"\",\n  `tour_found_time` varchar(1048576) NULL COMMENT \"\",\n  `tour_found_date` varchar(1048576) NULL COMMENT \"\",\n  `tour_close_time` varchar(1048576) NULL COMMENT \"\",\n  `tour_close_date` varchar(1048576) NULL COMMENT \"\",\n  `is_fake_tour` int(11) NULL COMMENT \"\",\n  `is_tour_order` int(11) NULL COMMENT \"\",\n  `tour_split_cost` double NULL COMMENT \"\",\n  `tour_per_fee` double NULL COMMENT \"\",\n  `tour_np` double NULL COMMENT \"\",\n  `tour_total_fee` double NULL COMMENT \"\",\n  `tour_first_profit_rate` double NULL COMMENT \"\",\n  `is_tour_notice` int(11) NULL COMMENT \"\",\n  `is_tour_lead_order` int(11) NULL COMMENT \"\",\n  `is_sys_flt_used` int(11) NULL COMMENT \"\",\n  `is_sys_htl_used` int(11) NULL COMMENT \"\",\n  `is_sys_train_used` int(11) NULL COMMENT \"\",\n  `rcpt_type_code` int(11) NULL COMMENT \"\",\n  `rcpt_type` varchar(1048576) NULL COMMENT \"\",\n  `data_src` varchar(1048576) NULL COMMENT \"\",\n  `ctry_code` varchar(1048576) NULL COMMENT \"\",\n  `suc_no_bed_child_np` int(11) NULL COMMENT \"\",\n  `prd_biz_owner` varchar(1048576) NULL COMMENT \"\",\n  `htl_add_amt` double NULL COMMENT \"\",\n  `local_tag` varchar(1048576) NULL COMMENT \"\",\n  `ved_risk_fee` double NULL COMMENT \"\",\n  `pltf_risk_fee` double NULL COMMENT \"\",\n  `prepay_type_name` varchar(1048576) NULL COMMENT \"\",\n  `ved_confirm_dur_mins` int(11) NULL COMMENT \"\",\n  `confirm_prd_time` varchar(1048576) NULL COMMENT \"\",\n  `total_price` double NULL COMMENT \"\",\n  `hold_confirm_status_code` varchar(1048576) NULL COMMENT \"\",\n  `hold_confirm_status` varchar(1048576) NULL COMMENT \"\",\n  `hold_payment_status_code` varchar(1048576) NULL COMMENT \"\",\n  `hold_payment_status` varchar(1048576) NULL COMMENT \"\",\n  `dep_cont_id` int(11) NULL COMMENT \"\",\n  `dep_cont` varchar(1048576) NULL COMMENT \"\",\n  `buyer_ip` varchar(1048576) NULL COMMENT \"\",\n  `app_os` varchar(1048576) NULL COMMENT \"\",\n  `platform` varchar(1048576) NULL COMMENT \"\",\n  `alliance_name` varchar(1048576) NULL COMMENT \"\",\n  `biz_channel_aggr` varchar(1048576) NULL COMMENT \"\",\n  `biz_channel_lvl1` varchar(1048576) NULL COMMENT \"\",\n  `biz_channel_lvl2` varchar(1048576) NULL COMMENT \"\",\n  `biz_channel_lvl3` varchar(1048576) NULL COMMENT \"\",\n  `cstcprm_suc_promo_inner_fee` double NULL COMMENT \"\",\n  `cstcother_suc_promo_inner_fee` double NULL COMMENT \"\",\n  `tour_region_type` varchar(1048576) NULL COMMENT \"\",\n  `cur_prd_tags` varchar(1048576) NULL COMMENT \"\",\n  `suc_dec_prmfee_profit` double NULL COMMENT \"\",\n  `suc_dec_prmfee_income` double NULL COMMENT \"\",\n  `suc_dec_innerfee_profit` double NULL COMMENT \"\",\n  `suc_dec_innerfee_income` double NULL COMMENT \"\",\n  `promo_strategy_desc` varchar(1048576) NULL COMMENT \"\",\n  `promo_draw_start_date` varchar(1048576) NULL COMMENT \"\",\n  `promo_draw_end_date` varchar(1048576) NULL COMMENT \"\",\n  `promo_use_start_time` varchar(1048576) NULL COMMENT \"\",\n  `promo_use_end_time` varchar(1048576) NULL COMMENT \"\",\n  `is_highmbr_discnt_tag` int(11) NULL COMMENT \"\",\n  `is_highmbr_discnt_order` int(11) NULL COMMENT \"\",\n  `site_name` varchar(1048576) NULL COMMENT \"\",\n  `mkt_sub_activity_id` bigint(20) NULL COMMENT \"\",\n  `mkt_apply_type_code` int(11) NULL COMMENT \"\",\n  `mkt_apply_type` varchar(1048576) NULL COMMENT \"\",\n  `mkt_fee_type_code` int(11) NULL COMMENT \"\",\n  `mkt_fee_type` varchar(1048576) NULL COMMENT \"\",\n  `mkt_comsn_fee` decimal128(19, 4) NULL COMMENT \"\",\n  `mkt_comsn_amt` double NULL COMMENT \"\",\n  `alliance_type_code` int(11) NULL COMMENT \"\",\n  `alliance_type_name` varchar(1048576) NULL COMMENT \"\",\n  `is_poi_sameprov` int(11) NULL COMMENT \"\",\n  `uid_residence_city_id` int(11) NULL COMMENT \"\",\n  `res_tour` varchar(1048576) NULL COMMENT \"\",\n  `around_tag` varchar(1048576) NULL COMMENT \"\",\n  `local_tour` varchar(1048576) NULL COMMENT \"\",\n  `pay_income` double NULL COMMENT \"\",\n  `user_star_lvl` int(11) NULL COMMENT \"\",\n  `plc_prd_tags` varchar(1048576) NULL COMMENT \"\",\n  `first_reason_key` varchar(1048576) NULL COMMENT \"\",\n  `first_reason_key_name` varchar(1048576) NULL COMMENT \"\",\n  `second_reason_key` varchar(1048576) NULL COMMENT \"\",\n  `second_reason_key_name` varchar(1048576) NULL COMMENT \"\",\n  `is_child_prd` int(11) NULL COMMENT \"\",\n  `resfull_loss_owner` varchar(1048576) NULL COMMENT \"\",\n  `is_flt_discnt_order` int(11) NULL COMMENT \"\",\n  `is_dur_tour` int(11) NULL COMMENT \"\",\n  `is_full_recv` int(11) NULL COMMENT \"\",\n  `uid_residence_city` varchar(1048576) NULL COMMENT \"\",\n  `uid_residence_prov_id` int(11) NULL COMMENT \"\",\n  `uid_residence_prov` varchar(1048576) NULL COMMENT \"\",\n  `uid_residence_ctry_id` int(11) NULL COMMENT \"\",\n  `uid_residence_ctry` varchar(1048576) NULL COMMENT \"\",\n  `remark` varchar(1048576) NULL COMMENT \"\",\n  `cur_user_mbr_lvl` varchar(1048576) NULL COMMENT \"\",\n  `outer_ved_promo_amt` double NULL COMMENT \"\",\n  `is_infprd_order` int(11) NULL COMMENT \"\",\n  `invoice_company_id` bigint(20) NULL COMMENT \"\",\n  `invoice_company_name` varchar(1048576) NULL COMMENT \"\",\n  `cpr_area_name` varchar(1048576) NULL COMMENT \"\",\n  `is_cpr_order` int(11) NULL COMMENT \"\",\n  `tour_region_type_byregion` varchar(1048576) NULL COMMENT \"\",\n  `dest_first_region_abn` varchar(1048576) NULL COMMENT \"\",\n  `thm_tagid` int(11) NULL COMMENT \"\",\n  `thm_tagname` varchar(1048576) NULL COMMENT \"\",\n  `process_op` varchar(1048576) NULL COMMENT \"\",\n  `plc_sale_mode_code` varchar(1048576) NULL COMMENT \"\",\n  `plc_sale_mode` varchar(1048576) NULL COMMENT \"\",\n  `is_super_order` int(11) NULL COMMENT \"\",\n  `pay_deduct_amt` double NULL COMMENT \"\",\n  `tour_region_type_dtl` varchar(1048576) NULL COMMENT \"\",\n  `is_presale_order` int(11) NULL COMMENT \"\",\n  `pos_city_id` int(11) NULL COMMENT \"\",\n  `pos_city` varchar(1048576) NULL COMMENT \"\",\n  `pos_prov_id` int(11) NULL COMMENT \"\",\n  `pos_prov` varchar(1048576) NULL COMMENT \"\",\n  `pos_ctry_id` int(11) NULL COMMENT \"\",\n  `pos_ctry` varchar(1048576) NULL COMMENT \"\",\n  `pos_cont_id` int(11) NULL COMMENT \"\",\n  `pos_cont` varchar(1048576) NULL COMMENT \"\",\n  `is_presale_reserved` int(11) NULL COMMENT \"\",\n  `presale_reserve_time` varchar(1048576) NULL COMMENT \"\",\n  `presale_reserve_date` varchar(1048576) NULL COMMENT \"\",\n  `presale_reserve_interval_days` int(11) NULL COMMENT \"\",\n  `is_tiktok_order` int(11) NULL COMMENT \"\",\n  `presale_status` varchar(1048576) NULL COMMENT \"\",\n  `distr_order_id` varchar(1048576) NULL COMMENT \"\",\n  `is_nointerest_installment` int(11) NULL COMMENT \"\",\n  `loan_terms` varchar(1048576) NULL COMMENT \"\",\n  `install_prepay_type_names` varchar(1048576) NULL COMMENT \"\",\n  `total_installment_amt` double NULL COMMENT \"\",\n  `installment_service_fee` double NULL COMMENT \"\",\n  `plc_brand_id` bigint(20) NULL COMMENT \"\",\n  `plc_brand_name` varchar(1048576) NULL COMMENT \"\",\n  `is_act_biz_order` int(11) NULL COMMENT \"\",\n  `d` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`order_id`)\n DISTRIBUTED BY HASH(`order_id`) BUCKETS 64 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "dw_diydb.vacation_permission" :"CREATE TABLE `vacation_permission` (\n  `userno` varchar(1048576) NULL COMMENT \"\",\n  `username` varchar(1048576) NULL COMMENT \"\",\n  `hashighpermission` varchar(1048576) NULL COMMENT \"\",\n  `pm_eid` varchar(1048576) NULL COMMENT \"\",\n  `pm_eidname` varchar(1048576) NULL COMMENT \"\",\n  `pbmeid` varchar(1048576) NULL COMMENT \"\",\n  `pbmeidname` varchar(1048576) NULL COMMENT \"\",\n  `salemode` varchar(1048576) NULL COMMENT \"\",\n  `startcityregion` varchar(1048576) NULL COMMENT \"\",\n  `domain` varchar(1048576) NULL COMMENT \"\",\n  `destfirstregion` varchar(1048576) NULL COMMENT \"\",\n  `destsecregion` varchar(1048576) NULL COMMENT \"\",\n  `productpatternname` varchar(1048576) NULL COMMENT \"\",\n  `butype` varchar(1048576) NULL COMMENT \"\",\n  `distributionchannel` varchar(1048576) NULL COMMENT \"\",\n  `productpatternid` int(11) NULL COMMENT \"\",\n  `local_tag` varchar(1048576) NULL COMMENT \"\",\n  `biz_channel_aggr` varchar(1048576) NULL COMMENT \"\",\n  `departureprovince_id` varchar(1048576) NULL COMMENT \"\",\n  `departureprovince` varchar(1048576) NULL COMMENT \"\",\n  `departurecity_id` varchar(1048576) NULL COMMENT \"\",\n  `departurecity` varchar(1048576) NULL COMMENT \"\",\n  `productregion_id` varchar(1048576) NULL COMMENT \"\",\n  `productregion` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`userno`)\n DISTRIBUTED BY HASH(`userno`) BUCKETS 64 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "dw_diydb.vacationcomplaint_widetable" :"CREATE TABLE `vacationcomplaint_widetable` (\n  `complaintsid` int(11) NULL COMMENT \"\",\n  `orderid` bigint(20) NULL COMMENT \"\",\n  `uid` varchar(1048576) NULL COMMENT \"\",\n  `isexpedited` varchar(1048576) NULL COMMENT \"\",\n  `language` varchar(1048576) NULL COMMENT \"\",\n  `complaintsstate` varchar(1048576) NULL COMMENT \"\",\n  `producttypename` varchar(1048576) NULL COMMENT \"\",\n  `replytype` varchar(1048576) NULL COMMENT \"\",\n  `membergrade` varchar(1048576) NULL COMMENT \"\",\n  `sex` varchar(1048576) NULL COMMENT \"\",\n  `poolid` bigint(20) NULL COMMENT \"\",\n  `detail` varchar(1048576) NULL COMMENT \"\",\n  `userdetail` varchar(1048576) NULL COMMENT \"\",\n  `complaintsource` varchar(1048576) NULL COMMENT \"\",\n  `uidtype` varchar(1048576) NULL COMMENT \"\",\n  `issuetime` varchar(1048576) NULL COMMENT \"\",\n  `issueeid` varchar(1048576) NULL COMMENT \"\",\n  `issueeidname` varchar(1048576) NULL COMMENT \"\",\n  `issueeiddept` varchar(1048576) NULL COMMENT \"\",\n  `issueeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `entrydepartment` varchar(1048576) NULL COMMENT \"\",\n  `closeeid` varchar(1048576) NULL COMMENT \"\",\n  `closeeidname` varchar(1048576) NULL COMMENT \"\",\n  `closeeiddept` varchar(1048576) NULL COMMENT \"\",\n  `closeeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `closetime` varchar(1048576) NULL COMMENT \"\",\n  `firstoperateeid` varchar(1048576) NULL COMMENT \"\",\n  `firstoperateeidname` varchar(1048576) NULL COMMENT \"\",\n  `firstoperateeiddept` varchar(1048576) NULL COMMENT \"\",\n  `firstoperateeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `firstoperatetime` varchar(1048576) NULL COMMENT \"\",\n  `keyword` varchar(1048576) NULL COMMENT \"\",\n  `adjustpoint` int(11) NULL COMMENT \"\",\n  `urgetimes` int(11) NULL COMMENT \"\",\n  `datasource` varchar(1048576) NULL COMMENT \"\",\n  `groupid` int(11) NULL COMMENT \"\",\n  `pointid` int(11) NULL COMMENT \"\",\n  `orderlist` varchar(1048576) NULL COMMENT \"\",\n  `groupcreateeid` varchar(1048576) NULL COMMENT \"\",\n  `groupcreateeidname` varchar(1048576) NULL COMMENT \"\",\n  `groupcreateeiddept` varchar(1048576) NULL COMMENT \"\",\n  `groupcreateeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `adepartment` varchar(1048576) NULL COMMENT \"\",\n  `bdepartment` varchar(1048576) NULL COMMENT \"\",\n  `analysis` varchar(1048576) NULL COMMENT \"\",\n  `secanalysis` varchar(1048576) NULL COMMENT \"\",\n  `paymentmin` decimal128(19, 4) NULL COMMENT \"\",\n  `paymentmax` decimal128(19, 4) NULL COMMENT \"\",\n  `paymentmoney` decimal128(19, 4) NULL COMMENT \"\",\n  `responsibilityremark` varchar(1048576) NULL COMMENT \"\",\n  `reason` varchar(1048576) NULL COMMENT \"\",\n  `responsibilitycreateeid` varchar(1048576) NULL COMMENT \"\",\n  `responsibilitycreateeidname` varchar(1048576) NULL COMMENT \"\",\n  `responsibilitycreateeiddept` varchar(1048576) NULL COMMENT \"\",\n  `responsibilitycreateeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `isvacation` varchar(1048576) NULL COMMENT \"\",\n  `vacationpdid` varchar(1048576) NULL COMMENT \"\",\n  `supplierid` varchar(1048576) NULL COMMENT \"\",\n  `isctripemp` varchar(1048576) NULL COMMENT \"\",\n  `responsibilityempeid` varchar(1048576) NULL COMMENT \"\",\n  `responsibilityempeidname` varchar(1048576) NULL COMMENT \"\",\n  `responsibilityempeiddept` varchar(1048576) NULL COMMENT \"\",\n  `responsibilityempeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `responsibilitydetailcreateeid` varchar(1048576) NULL COMMENT \"\",\n  `responsibilitydetailcreateeidname` varchar(1048576) NULL COMMENT \"\",\n  `responsibilitydetailcreateeiddept` varchar(1048576) NULL COMMENT \"\",\n  `responsibilitydetailcreateeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `resulttype` varchar(1048576) NULL COMMENT \"\",\n  `totalmoney` decimal128(19, 4) NULL COMMENT \"\",\n  `ordertkmoney` decimal128(19, 4) NULL COMMENT \"\",\n  `orderpkmoney` decimal128(19, 4) NULL COMMENT \"\",\n  `integralcompensate` decimal128(19, 4) NULL COMMENT \"\",\n  `goodssupplement` decimal128(19, 4) NULL COMMENT \"\",\n  `indemnitypaytype` varchar(1048576) NULL COMMENT \"\",\n  `indemnitymoney` decimal128(19, 4) NULL COMMENT \"\",\n  `advancespaytype` varchar(1048576) NULL COMMENT \"\",\n  `advancesmoney` decimal128(19, 4) NULL COMMENT \"\",\n  `refundpaytype` varchar(1048576) NULL COMMENT \"\",\n  `refundmoney` decimal128(19, 4) NULL COMMENT \"\",\n  `resultcreateeid` varchar(1048576) NULL COMMENT \"\",\n  `resultcreateeidname` varchar(1048576) NULL COMMENT \"\",\n  `resultcreateeiddept` varchar(1048576) NULL COMMENT \"\",\n  `resultcreateeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `claimvalue` decimal128(19, 4) NULL COMMENT \"\",\n  `customersatisfaction` varchar(1048576) NULL COMMENT \"\",\n  `resultremark` varchar(1048576) NULL COMMENT \"\",\n  `resultdetailcreateeid` varchar(1048576) NULL COMMENT \"\",\n  `resultdetailcreateeidname` varchar(1048576) NULL COMMENT \"\",\n  `resultdetailcreateeiddept` varchar(1048576) NULL COMMENT \"\",\n  `resultdetailcreateeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `prizename` varchar(1048576) NULL COMMENT \"\",\n  `baddebts` decimal64(10, 0) NULL COMMENT \"\",\n  `cash` decimal64(10, 0) NULL COMMENT \"\",\n  `tmcount` decimal64(10, 0) NULL COMMENT \"\",\n  `safety` decimal64(10, 0) NULL COMMENT \"\",\n  `coupon` decimal64(10, 0) NULL COMMENT \"\",\n  `wallet` decimal64(10, 0) NULL COMMENT \"\",\n  `vipcardnumber` int(11) NULL COMMENT \"\",\n  `freeroomnumber` int(11) NULL COMMENT \"\",\n  `isintime` varchar(1048576) NULL COMMENT \"\",\n  `isclosein1day` varchar(1048576) NULL COMMENT \"\",\n  `isclosein2days` varchar(1048576) NULL COMMENT \"\",\n  `transgroup` varchar(1048576) NULL COMMENT \"\",\n  `closelength` decimal64(18, 2) NULL COMMENT \"\",\n  `channel_name` varchar(1048576) NULL COMMENT \"\",\n  `pkg` bigint(20) NULL COMMENT \"\",\n  `pkgname` varchar(1048576) NULL COMMENT \"\",\n  `productcategoryname` varchar(1048576) NULL COMMENT \"\",\n  `productpatternname` varchar(1048576) NULL COMMENT \"\",\n  `salemode` varchar(1048576) NULL COMMENT \"\",\n  `distributionchannel` varchar(1048576) NULL COMMENT \"\",\n  `productlevel` varchar(1048576) NULL COMMENT \"\",\n  `pm_eid` varchar(1048576) NULL COMMENT \"\",\n  `providerid` bigint(20) NULL COMMENT \"\",\n  `providername` varchar(1048576) NULL COMMENT \"\",\n  `providerlist` varchar(1048576) NULL COMMENT \"\",\n  `providernamelist` varchar(1048576) NULL COMMENT \"\",\n  `isdistribute` varchar(1048576) NULL COMMENT \"\",\n  `skuid` bigint(20) NULL COMMENT \"\",\n  `sku_providerid` bigint(20) NULL COMMENT \"\",\n  `sku_providername` varchar(1048576) NULL COMMENT \"\",\n  `orderdate` varchar(1048576) NULL COMMENT \"\",\n  `startdate` varchar(1048576) NULL COMMENT \"\",\n  `returndate` varchar(1048576) NULL COMMENT \"\",\n  `startcity` varchar(1048576) NULL COMMENT \"\",\n  `salescity` varchar(1048576) NULL COMMENT \"\",\n  `destcity` varchar(1048576) NULL COMMENT \"\",\n  `destcountry` varchar(1048576) NULL COMMENT \"\",\n  `destprovince` varchar(1048576) NULL COMMENT \"\",\n  `destfirstregion` varchar(1048576) NULL COMMENT \"\",\n  `domain` varchar(1048576) NULL COMMENT \"\",\n  `financialbu` varchar(1048576) NULL COMMENT \"\",\n  `financialsalemode` varchar(1048576) NULL COMMENT \"\",\n  `isdiysuborder` varchar(1048576) NULL COMMENT \"\",\n  `amount` double NULL COMMENT \"\",\n  `amountvs` double NULL COMMENT \"\",\n  `processoper` varchar(1048576) NULL COMMENT \"\",\n  `processeidname` varchar(1048576) NULL COMMENT \"\",\n  `processeiddept` varchar(1048576) NULL COMMENT \"\",\n  `processeidgroup` varchar(1048576) NULL COMMENT \"\",\n  `resourcetype` varchar(1048576) NULL COMMENT \"\",\n  `fltitemnum` int(11) NULL COMMENT \"\",\n  `sysfltorders` int(11) NULL COMMENT \"\",\n  `syshtlcancelorders` int(11) NULL COMMENT \"\",\n  `syshtlsuccessorders` int(11) NULL COMMENT \"\",\n  `pkghtlcancelorders` int(11) NULL COMMENT \"\",\n  `pkghtlsuccessorders` int(11) NULL COMMENT \"\",\n  `hassysflight` varchar(1048576) NULL COMMENT \"\",\n  `hassyshotel` varchar(1048576) NULL COMMENT \"\",\n  `subshortname` varchar(1048576) NULL COMMENT \"\",\n  `process` varchar(1048576) NULL COMMENT \"\",\n  `customerprice` int(11) NULL COMMENT \"\",\n  `fisrtassessmentindex` varchar(1048576) NULL COMMENT \"\",\n  `fullcompensation` decimal64(10, 0) NULL COMMENT \"\",\n  `firsturgetime` varchar(1048576) NULL COMMENT \"\",\n  `responsetime` varchar(1048576) NULL COMMENT \"\",\n  `destsecregion` varchar(1048576) NULL COMMENT \"\",\n  `6381pkgregion` varchar(1048576) NULL COMMENT \"\",\n  `indemnitydepartment` varchar(1048576) NULL COMMENT \"\",\n  `isassess` varchar(1048576) NULL COMMENT \"\",\n  `isbusinessnew` varchar(1048576) NULL COMMENT \"\",\n  `fircloseeid` varchar(1048576) NULL COMMENT \"\",\n  `firclosedeptname` varchar(1048576) NULL COMMENT \"\",\n  `firclosegroupname` varchar(1048576) NULL COMMENT \"\",\n  `firclosetime` varchar(1048576) NULL COMMENT \"\",\n  `fircloseeidname` varchar(1048576) NULL COMMENT \"\",\n  `context` varchar(1048576) NULL COMMENT \"\",\n  `totalvaluecurrency` varchar(1048576) NULL COMMENT \"\",\n  `totalvalueexchangerate` double NULL COMMENT \"\",\n  `DUPLICATEsf_name` varchar(1048576) NULL COMMENT \"\",\n  `secondarysf_name` varchar(1048576) NULL COMMENT \"\",\n  `d` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`complaintsid`)\n DISTRIBUTED BY HASH(`complaintsid`) BUCKETS 64 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "ods_vacdb.m_tourqualitycenterdb_qa_quality" :"CREATE TABLE `m_tourqualitycenterdb_qa_quality` (\n  `quality_id` bigint(20) NOT NULL COMMENT \"\",\n  `stage` smallint(6) NULL COMMENT \"\",\n  `business_line` smallint(6) NULL COMMENT \"\",\n  `business_line_name` varchar(1048576) NULL COMMENT \"\",\n  `exam_target_id` bigint(20) NULL COMMENT \"\",\n  `third_exam_target` varchar(1048576) NULL COMMENT \"\",\n  `source_from` varchar(1048576) NULL COMMENT \"\",\n  `complain_up_factor` decimal64(10, 2) NULL COMMENT \"\",\n  `detail` varchar(1048576) NULL COMMENT \"\",\n  `fault_depart` smallint(6) NULL COMMENT \"\",\n  `fault_category` varchar(1048576) NULL COMMENT \"\",\n  `status` varchar(1048576) NULL COMMENT \"\",\n  `first_reason` varchar(1048576) NULL COMMENT \"\",\n  `second_reason` varchar(1048576) NULL COMMENT \"\",\n  `orderid` bigint(20) NULL COMMENT \"\",\n  `order_uid` varchar(1048576) NULL COMMENT \"\",\n  `complainid` bigint(20) NULL COMMENT \"\",\n  `commentid` bigint(20) NULL COMMENT \"\",\n  `productid` bigint(20) NULL COMMENT \"\",\n  `providerid` bigint(20) NULL COMMENT \"\",\n  `resourceid` bigint(20) NULL COMMENT \"\",\n  `mainland` smallint(6) NULL COMMENT \"\",\n  `sale_model` varchar(1048576) NULL COMMENT \"\",\n  `distribution_channel` varchar(1048576) NULL COMMENT \"\",\n  `pm_eid` varchar(1048576) NULL COMMENT \"\",\n  `pa_eid` varchar(1048576) NULL COMMENT \"\",\n  `product_category` smallint(6) NULL COMMENT \"\",\n  `product_type` smallint(6) NULL COMMENT \"\",\n  `region` smallint(6) NULL COMMENT \"\",\n  `province` varchar(1048576) NULL COMMENT \"\",\n  `locale` varchar(1048576) NULL COMMENT \"\",\n  `grade` smallint(6) NULL COMMENT \"\",\n  `departure_date` varchar(1048576) NULL COMMENT \"\",\n  `order_date` varchar(1048576) NULL COMMENT \"\",\n  `use_date` varchar(1048576) NULL COMMENT \"\",\n  `expire_date` varchar(1048576) NULL COMMENT \"\",\n  `appeal_eventid` bigint(20) NULL COMMENT \"\",\n  `appeal_eid` varchar(1048576) NULL COMMENT \"\",\n  `seriousness` varchar(1048576) NULL COMMENT \"\",\n  `audit_eventid` bigint(20) NULL COMMENT \"\",\n  `isactive` smallint(6) NULL COMMENT \"\",\n  `datachange_lasttime` varchar(1048576) NULL COMMENT \"\",\n  `datachange_lastby` varchar(1048576) NULL COMMENT \"\",\n  `datachange_createtime` varchar(1048576) NULL COMMENT \"\",\n  `datachange_createby` varchar(1048576) NULL COMMENT \"\",\n  `aiid` bigint(20) NULL COMMENT \"\",\n  `production_line` varchar(1048576) NULL COMMENT \"\",\n  `require_order_second_region` varchar(1048576) NULL COMMENT \"\",\n  `provider_type` varchar(1048576) NULL COMMENT \"\",\n  `third_reason` varchar(1048576) NULL COMMENT \"\",\n  `qa_temp_ai_quality_id` bigint(20) NULL COMMENT \"\",\n  `fault_employee_name` varchar(1048576) NULL COMMENT \"\",\n  `fault_employee_group` varchar(1048576) NULL COMMENT \"\",\n  `eventid` bigint(20) NULL COMMENT \"\",\n  `ischecking` smallint(6) NULL COMMENT \"\",\n  `biid` bigint(20) NULL COMMENT \"\",\n  `advisorid` bigint(20) NULL COMMENT \"\",\n  `quality_type` smallint(6) NULL COMMENT \"\",\n  `ordkey` bigint(20) NULL COMMENT \"\",\n  `pardonid` bigint(20) NULL COMMENT \"\",\n  `book_vehicle` varchar(1048576) NULL COMMENT \"\",\n  `assign_vehicle` varchar(1048576) NULL COMMENT \"\",\n  `is_ibu` int(11) NULL COMMENT \"\",\n  `sign_place` varchar(1048576) NULL COMMENT \"\",\n  `collectmaterialtime` varchar(1048576) NULL COMMENT \"\",\n  `govaudittime` varchar(1048576) NULL COMMENT \"\",\n  `govauditname` varchar(1048576) NULL COMMENT \"\",\n  `uploadtime` varchar(1048576) NULL COMMENT \"\",\n  `sendsigneddate` varchar(1048576) NULL COMMENT \"\",\n  `visastuffmaketime` varchar(1048576) NULL COMMENT \"\",\n  `advisorchname` varchar(1048576) NULL COMMENT \"\",\n  `fault_employee` varchar(1048576) NULL COMMENT \"\",\n  `business_status` int(11) NULL COMMENT \"\",\n  `regionname` varchar(1048576) NULL COMMENT \"\",\n  `templusdatagroupcode` varchar(1048576) NULL COMMENT \"\",\n  `sub_butypename` varchar(1048576) NULL COMMENT \"\",\n  `sub_butypecode` int(11) NULL COMMENT \"\",\n  `datachange_lastbyeid` varchar(1048576) NULL COMMENT \"\",\n  `datachange_lasttimebyeid` varchar(1048576) NULL COMMENT \"\",\n  `insurancetype` varchar(1048576) NULL COMMENT \"\",\n  `d` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`quality_id`)\n DISTRIBUTED BY HASH(`quality_id`) BUCKETS 64 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);" },
  "table_row_count": { "dw_diydb.adm_sev_qa_quality_dmt_t": { "adm_sev_qa_quality_dmt_t": 2000000 },
    "dw_diydb.dim_prd_tor_pkg_ext": { "dim_prd_tor_pkg_ext": 270000 },
    "dw_diydb.edw_ord_tor_order_ext_d": { "edw_ord_tor_order_ext_d": 6156 },
    "dw_diydb.vacation_permission": { "vacation_permission": 2910 },
    "dw_diydb.vacationcomplaint_widetable": { "vacationcomplaint_widetable": 2910 },
    "ods_vacdb.m_tourqualitycenterdb_qa_quality": { "m_tourqualitycenterdb_qa_quality": 2910 }
  },
  "session_variables" :"{\"enable_show_all_variables\":false,\"partial_update_mode\":\"auto\",\"cbo_cte_reuse\":true,\"full_sort_max_buffered_bytes\":16777216,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_connector_adaptive_io_tasks\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"enable_hive_metadata_cache_with_insert\":false,\"cbo_cte_reuse_rate_v2\":1.15,\"transmission_encode_level\":7,\"character_set_results\":\"utf8\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"enable_load_profile\":false,\"enable_plan_validation\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"scan_use_query_mem_ratio\":0.3,\"enable_rewrite_simple_agg_to_meta_scan\":false,\"new_planner_optimize_timeout\":3000000,\"enable_outer_join_reorder\":true,\"enable_adaptive_sink_dop\":true,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"full_sort_late_materialization\":false,\"enable_profile\":false,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"range_pruner_max_predicate\":100,\"spillable_operator_mask\":-1,\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"rpc_http_min_size\":2147482624,\"disable_function_fold_constants\":false,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"scan_or_to_union_limit\":4,\"enable_parallel_merge\":true,\"select_ratio_threshold\":0.15,\"nested_mv_rewrite_max_level\":3,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"spill_mem_table_size\":104857600,\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"pipeline_sink_dop\":0,\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"profile_limit_fold\":true,\"spill_operator_max_bytes\":1048576000,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"cbo_max_reorder_node_use_dp\":10,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"connector_scan_use_query_mem_ratio\":0.3,\"net_buffer_length\":16384,\"cbo_prune_subfield\":true,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"full_sort_max_buffered_rows\":1024000,\"query_cache_agg_cardinality_limit\":5000000,\"query_timeout\":300,\"connector_io_tasks_slow_io_latency_ms\":50,\"enable_pipeline_query_statistic\":true,\"cbo_max_reorder_node\":50,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"enable_distinct_column_bucketization\":false,\"enable_big_query_log\":true,\"interpolate_passthrough\":true,\"enable_incremental_mv\":false,\"analyze_mv\":\"sample\",\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"enable_sync_materialized_view_rewrite\":true,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"enable_strict_type\":false,\"max_pipeline_dop\":64,\"broadcast_right_table_scale_factor\":10,\"group_concat_max_len\":65535,\"enable_simplify_case_when\":true,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"big_query_log_cpu_second_threshold\":480,\"enable_scan_block_cache\":true,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"div_precision_increment\":4,\"runtime_adaptive_dop_max_block_rows_per_driver_seq\":16384,\"log_rejected_record_num\":0,\"auto_increment_increment\":1,\"sql_dialect\":\"StarRocks\",\"cbo_push_down_distinct_below_window\":true,\"sql_mode_v2\":32,\"big_query_log_scan_rows_threshold\":1000000000,\"character_set_client\":\"utf8\",\"autocommit\":true,\"hdfs_backend_selector_scan_range_shuffle\":false,\"enable_column_expr_predicate\":true,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"enable_runtime_adaptive_dop\":false,\"cbo_cte_max_limit\":10,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"hive_partition_stats_sample_size\":3000,\"enable_optimizer_trace_log\":false,\"enable_mv_planner\":false,\"spill_operator_min_bytes\":10485760,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"spill_mem_table_num\":2,\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"enable_spill\":false,\"spill_encode_level\":7,\"pipeline_dop\":0,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"enable_rewrite_sum_by_associative_rule\":true,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_parallel_scan_instance_num\":-1,\"query_cache_entry_max_rows\":409600,\"max_pushdown_conditions_per_column\":-1,\"enable_mv_optimizer_trace_log\":false,\"connector_io_tasks_per_scan_operator\":16,\"default_table_compression\":\"lz4_frame\",\"enable_materialized_view_union_rewrite\":true,\"runtime_adaptive_dop_max_output_amplification_factor\":0,\"sql_quote_show_create\":true,\"scan_or_to_union_threshold\":50000000,\"enable_exchange_pass_through\":true,\"query_cache_entry_max_bytes\":4194304,\"innodb_read_only\":true,\"spill_mem_limit_threshold\":0.8,\"cbo_reorder_threshold_use_exhaustive\":6,\"enable_exchange_perf\":false,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"enable_query_cache\":false,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"use_page_cache\":true,\"max_allowed_packet\":33554432,\"big_query_log_scan_bytes_threshold\":10737418240,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"spill_mode\":\"auto\",\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}",
  "column_statistics": { "dw_diydb.vacationcomplaint_widetable": { "d" :"[NaN, NaN, 0.0, 4.477867245565344E-6, 1.0] ESTIMATE",
    "issuetime" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
    "closetime" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
    "complaintsource" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
    "complaintsid" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN" },
    "dw_diydb.dim_prd_tor_pkg_ext": { "productid" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "d" :"[NaN, NaN, 0.0, 7.50159127504922E-7, 1.0] ESTIMATE",
      "is_gold_guider_prd" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN" },
    "dw_diydb.adm_sev_qa_quality_dmt_t": { "origin_fault_category_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "second_exam_target" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "customerprice" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "source_from_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "departure_date" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "dest_province_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "distribution_channel_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "complain_up_factor" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "business_line_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "product_category_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "domain_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "product_level_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "product_category_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "domain_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "sale_model_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "timeanswer" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "product_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "is_cpr_order" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "is_core_problem" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "business_line" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "product_level_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "complain_orderid" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "qa_pkgregion" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "fault_category_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "second_reason" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "complain_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "communication_cost" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "third_exam_target" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "origin_fault_category_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "qa_problem_segment" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "servicelabor_cost" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "first_exam_target" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "destination_city" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "source_from_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "themetagname" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "tour_region_type" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "pm_eid" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "quality_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "third_reason" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "provider_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "quality_cost" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "product_pattern_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "is_business_reason" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "return_date" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "destination_country" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "sale_model_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "unit_quality_cost" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "pkg_region" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "origin_first_reason" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "customer_feel" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "business_reason_orderid" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "weekinput" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "qa_index" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "provider_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "is_examine" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "paymentmoney" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "qa_region_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "orderid" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "customer_value" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "origin_second_reason" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "local_tag" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "product_pattern_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "distribution_channel_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "alloc_coefficient" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "prd_line_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "fault_category_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "order_date" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "b_quality_cost" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "first_reason" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "a_quality_cost" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN" },
    "ods_vacdb.m_tourqualitycenterdb_qa_quality": { "d" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "quality_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "datachange_createtime" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "detail" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "status" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN" },
    "dw_diydb.vacation_permission": { "distributionchannel" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "domain" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "userno" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "destfirstregion" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "salemode" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "productpatternname" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "destsecregion" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "butype" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN" },
    "dw_diydb.edw_ord_tor_order_ext_d": { "dep_prov" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "prd_pat_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "sale_mode" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "d" :"[NaN, NaN, 0.0, 2.735638234385162E-7, 1.0] ESTIMATE",
      "vendor_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "dep_city" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "dest_second_region" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "plc_prd_tags" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "distr_channel" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "dest_domain" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "cpr_area_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "bu_type" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "plc_prd_name" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "order_id" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "dest_first_region" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "return_date" :"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN" } },
  "be_number" :9,
  "be_core_stat": { "numOfHardwareCoresPerBe" :"{\"10006\":40,\"10007\":40,\"10008\":40,\"10009\":32,\"10010\":32,\"10011\":32,\"10012\":32,\"10013\":32,\"10014\":32}",
    "cachedAvgNumOfHardwareCores" :34 },
  "exception" :[],
  "version" :"3.1.0-rc01",
  "commit_version" :"64ca37e" }